home *** CD-ROM | disk | FTP | other *** search
/ Amiga Game-Power / Amiga Game-Power.iso / pd mix i / pict saver / analyrim / dbmsdocs.zoo / rimcrd.doc < prev    next >
Text File  |  1992-01-05  |  3KB  |  186 lines
  1. RIM Handy Reference Card
  2.  
  3. DEFINING A DATABASE SCHEMA
  4.     DEFINE dbname
  5.     OWNER password
  6.     ATTRIBUTES
  7.     attname    {REAL} [{length}][KEY]
  8.         INT     VAR
  9.         TEXT
  10.         DOUB
  11.         RVEC
  12.         IVEC
  13.         DVEC
  14.     attname    {RMAT}  {row,col} [KEY]
  15.         IMAT     row,VAR
  16.         DMAT     VAR,VAR
  17.     RELATIONS
  18.     relname WITH attname1 [attname2...]
  19.     PASSWORDS
  20.     {READ PASSWORD} FOR {relname} IS password
  21.     RPW            ALL
  22.     {MODIFY PASSWORD} FOR {relname} IS password
  23.     MPW            ALL
  24.     RULES
  25.     attname [IN relname]    {EQ} value [{AND}...]
  26.                  NE         OR
  27.                  GT
  28.                  GE
  29.                  LT
  30.                  LE
  31.     attname IN relname    {EQA} attname IN relname [{AND}...]
  32.                  NEA               OR
  33.                  GTA
  34.                  GEA
  35.                  LTA
  36.                  LEA
  37.     END
  38.  
  39. LOADING A RELATION
  40.     LOAD relname
  41.     value1 value2 ... valueN
  42.     END
  43.     value: SCALARS val1
  44.            TEXT "text string"
  45.            VECTOR (val1, val2, ...)
  46.            MATRIX(r1c1,r2c1,...),(r1c2,r2c2,...)...)
  47.  
  48. QUERYING A RELATION
  49.     SELECT {attname1 [=fid1],attname2[=fid2],...} FROM relname +
  50.         attnum1 [=fid1],...
  51.         attname1(i),...
  52.         attname1(i,j)...
  53.         ALL
  54.         [SORTED BY attname1 [={A}],[attname2 [={A}]...]]+
  55.                        D                D
  56.         [WHERE ...]
  57.     TALLY attname [={A}] FROM relname [WHERE...]
  58.              D
  59.  
  60.     WHERE CLAUSE:
  61.  
  62.     WHERE    attname        {EXISTS}        [{AND}...]
  63.                  FAILS              OR
  64.                  EQS    value
  65.                  EQ    {value}
  66.                  NE     MAX
  67.                  GT     MIN
  68.                  LT
  69.                  LE
  70.                  GE
  71.  
  72.     WHERE    attname        {EQA}    attname        [{AND}...]
  73.                  NEA              OR
  74.                  GTA
  75.                  GEA
  76.                  LTA
  77.                  LEA
  78.  
  79.     WHERE    ROWS        {EQ}    rownumber    [{AND}...]
  80.                  NE              OR
  81.                  LT
  82.                  LE
  83.                  GE
  84.                  GT
  85.  
  86.     WHERE    {attname}    {EQ}    list        [{AND}...]
  87.          ROWS         NE              OR
  88.  
  89.     WHERE    LIMIT        EQ    number        [{AND}...]
  90.                               OR
  91. ...
  92.  
  93. QUERYING THE SCHEMA
  94.  
  95.     LISTREL    [relname]
  96.          ALL
  97.     EXHIBIT attname1 [attname2...]
  98.     PRINT RULES
  99.  
  100. COMPUTATION COMMAND
  101.  
  102.     COMPUTE    {COUNT} attname FROM relname [WHERE...]
  103.          MIN
  104.          MAX
  105.          AVE
  106.          SUM
  107.  
  108. MODIFICATION COMMANDS
  109.  
  110.     CHANGE {attname} TO value [IN relname] WHERE ...
  111.         attname(i)
  112.         attname(i,j)
  113.     CHANGE {RPW} TO newpass FOR relname
  114.         MPW
  115.     CHANGE OWNER TO newowner
  116.     DELETE ROWS FROM relname WHERE ...
  117.     DELETE DUPLICATES [attname1,attname2,...] FROM relname
  118.     DELETE RULE rulenumber
  119.     RENAME ATTRIBUTE attname TO newname [IN relname]
  120.     RENAME RELATION relname TO newname
  121.     REMOVE relname
  122.  
  123. RELATIONAL ALGEBRA COMMANDS
  124.  
  125.     INTERSECT relname1 WITH relname2 FORMING relname3 +
  126.         [USING attname1 [attname2,...]]
  127.     JOIN relname1 Using attname1 WITH relname2 USING attname2 +
  128.         FORMING relname3 [WHERE {EQ}]
  129.                      NE
  130.                      GT
  131.                      GE
  132.                      LT
  133.                      LE
  134.     SUBTRACT relname1 FROM relname2 FORMING relname3 +
  135.         [USING attname1 [attname2,...]]
  136.     PROJECT relname1 FROM relname2 USING +
  137.         {attname1,[attname2,...]} [WHERE ...]
  138.          ALL
  139.  
  140. REPORT COMMANDS
  141.  
  142.     NEWPAGE
  143.     BLANK n
  144.     TITLE "title"
  145.     DATE
  146.     LINES n
  147.     WIDTH n
  148.  
  149. KEY COMMANDS
  150.  
  151.     BUILD KEY FOR attname IN relname
  152.     DELETE KEY FOR attname IN relname
  153.  
  154. RIM-TO-RIM COMMAND
  155.  
  156.     UNLOAD [dbname [=newdbname]]   {SCHEMA} [relname1 [=mpw] +
  157.                     DATA
  158.                     ALL
  159.         [relname2 [=mpw],...]
  160.  
  161. GENERAL COMMANDS
  162.  
  163.     INPUT {filename}
  164.            TERMINAL
  165.     OUTPUT {filename}
  166.            TERMINAL
  167.     EXIT
  168.     QUIT
  169.     MENU
  170.     HELP [command name]
  171.     USER password
  172.     ECHO
  173.     NOECHO
  174.     CHECK
  175.     NOCHECK
  176.     TOLERANCE xx.xx [PERCENT]
  177.     RELOAD
  178.     CLOSE
  179.  
  180. HOST DEPENDENT COMMANDS (note: may be CDC syntax)
  181.  
  182.     OPEN dbname [=filename],[UN=account],[PW=password],+
  183.         [DIRECT={R}]
  184.              W
  185.     ZIP "jet statement"
  186.